package com.zhiying.mybatis;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.session.RowBounds;

import com.zhiying.domain.OS_Product;
import com.zhiying.page.PageInfo;

public interface ProductMapper {

	//分页显示商品数据
	List<OS_Product> SelectAllinfo(@Param("pageInfo")PageInfo pageInfo, @Param("search")String search,RowBounds rowBounds);
	
	//修改商品状态
	int UpdateshowInShelve(@Param("product")OS_Product product);

	//根据id查询商品状态
	int SelectshowInShelveByid(@Param("id")Long id);
	
	//查询商品的总记录数
	int SelectAllCount(@Param("search")String search);
	
	//根据productNumber查询商品数据
	OS_Product SelectinfoByproductNumber(@Param("productNumber") Long productNumber);
	//根据productId删除商品数据
	int DeletinfoById(@Param("productId")Long productId);
	//根据productNumber来修改商品数据
	int UpdateinfoById(@Param("product")OS_Product product);
	//新增商品信息
	int InsertInfo(@Param("product")OS_Product product);
	
}